﻿CREATE VIEW dbo.vwParliamentarianUpdates
AS
SELECT     MPs.CPALId, MPs.MPID, MPs.Title, MPs.FirstName, MPs.Surname, Links.PartyWebsite, Links.PersonalWebsite, Links.FacebookAddress, Links.TwitterAddress, 
                      Links.EmailVisible, Links.ContactFormVisible, Links.Link1Label, Links.Link1Address, Links.Link2Label, Links.Link2Address, Links.Link3Label, Links.Link3Address, 
                      Links.Link4Label, Links.Link4Address, Links.Link5Label, Links.Link5Address, Links.ElectionMessage, Links.FirstSpeechLink, Links.ShortURL
FROM         dbo.ParliamentarianWebLinks AS Links RIGHT OUTER JOIN
                      dbo.Parliamentarians AS MPs ON Links.CPALId = MPs.CPALId
WHERE     (MPs.FormerMember = 0)